Cost Center File - FIL 24

Description/Instructions

Title or description of the cost center.

Enter notes concerning the use or definition of this cost center.

This field is optional. Enter a three-character code which groups or links cost centers together. For example, you could have 15 cost center codes broken into three groups such as sales related, inventory related and office related. Create three group codes such as SAL, INV and OFF and assign each of your 15 cost centers to one of the three group codes. The G/L Audit Report and spreadsheets can access cost centers specifically or by group.

D in this field indicates that this record will be deleted.

Description/Instructions

Enter a valid company number for which to display statistics.

Leave blank or enter ALL to see statistics for the entire company, combining all warehouses for that cost center. Enter a specific warehouse to limit statistics for that warehouse. Do not confuse warehouse with branch. The statistics relate to sales that used inventory from the specified warehouse.

• I - Limit to sales from stock only (inventory).

• D - Limit to direct ship sales only.

• C - Limit to intercompany sales only. This relates to customers coded with type IC for intercompany.

• S- Limit to sales that were coded as special orders.

Leave blank for all types of sales combined.

Description/Instructions

The previously selected company number.

The previously selected cost center, if you press F14 from the Cost Center File. If you are in the Company, Branch, or Warehouse Files,. this field is blank, indicating all cost centers combined.

The previously selected warehouse if you selected it from the Warehouse File. In other files, it displays blanks, indicating all warehouses combined, or it can display a previously selected warehouse. In the Branch File, this field is labeled Branch.

All system modules distinguish branch from warehouse. Since these statistics concern inventory, they affect warehouse figures directly. Because branches are selling organizations and not necessarily inventory organizations, these inventory statistics might not relate directly to branches. However, to provide maximum benefit to all system users, we have used the following logic in designing these screens. In the Warehouse File, Adjusted Gross Profit figures are strictly related to that warehouse. In the Branch File, all sales figures relate to the branch, but the inventory adjustment figures relate to the warehouse, if any, with the same code as the branch. For example, if you are displaying statistics for the RAL branch, inventory statistics show for the RAL warehouse. If this warehouse does not exist, no inventory figures are shown.

The current accounting month, based on the accounts receivable end-of-month close dates.

The 12 months immediately preceding the current month.

The 12 months immediately preceding the past 12 months.

The gross sales dollars for the category being displayed.

The gross sales minus the cost of sales.

The gross profit dollar amount divided by gross sales.

The various categories of inventory adjustments. Each inventory adjustment is put into one of the available categories. The figures displayed for each adjustment category are their total affect on inventory value in the period displayed. A negative value indicates a loss of inventory (as for write offs), and a positive value indicates an inventory gain. You can enter X beside any adjustment category to view the details that comprise the totals shown. Each item number, description, quantity, and so on, can be viewed. Press F18 to display all available adjustment codes.

The very first time the program is executed, all adjustment summary records are loaded. Once you press F18 and change the selection, and then press Enter to update, only your selections are displayed for that specific company, cost center, and warehouse combination

Total dollar value of all adjustment categories.

Gross profit amount minus the total adjustments, divided by gross sales. This figure shows the gross profit percentage including the effect of inventory adjustments. GP% is lowered if total adjustments are a negative number, and vice versa.

Cost of sales plus total adjustments, divided by average inventory value. This figure shows the turns including the effect of inventory adjustments. When computing adjusted turns, if total adjustments is a negative number, cost of sales is increased by that number, which then reduces turns.

This is the gross profit amount minus total adjustments, divided by average inventory value and multiplied by 100. This shows the GMROI including the effect of inventory adjustments. GMROI = Gross Margin Return on Inventory Investment.

Description

Go to the Cost Center File Sales Analysis screen. Press F4 again to display the Month-by-Month Sales Analysis screen.

Close the pop-up window and return to the previous screen.

Ends job and returns to the File Maintenance Menu.

Go to a list of all inventory adjustment codes and categories available on the system. From the list you can choose the adjustment types you want to include on the Adjusted Gross Profit display by typing an X next to your choices and pressing Enter twice. You can remove a category by removing the X and pressing Enter twice. For example, if you only want write-offs and damage to display on your Adjusted Gross Profit Analysis screen, press F18 to display a list of codes, and enter an X next to the W and D codes. Press Enter twice to activate your selection. Once selected, these choices remain in effect until you press F18 again. Press F18 to customize the categories displayed on the Adjusted Gross Profit display.